package pers.xx.sbm.dao;

import org.springframework.stereotype.Repository;
import pers.xx.sbm.vo.*;

import java.util.List;

@Repository
public interface DyReportCountyDataMapper {
    List<Integer> selectNumbers(String areaName);

    int selectSchoolNumbers(String areaName, String xd);

    Double queryTotalScore(int year, String areaName, String xd);

    List<TotalSampleVo> querySchoolScore(int year, String areaName, String xd,List<String> schoolNames);

    List<NumberSampleVo> queryNumber(String column,String areaName);

    List<ScoreSampleVo> queryIndexScore(String column,String areaName, String xd);

    List<DyIndexScore> queryScore1(int year, String areaName, String xd);

    List<DyIndexScore> queryScore2(int year, String areaName, String xd,List<String> parentIndexNameS);

    List<DyIndexScore> queryAllScore2(int year, String areaName);

    List<DyQuestion> queryQuestionScore(int year, String areaName, String indexName, String xd);

}
